Profiling Report Gebrauchtwagenset

Dataset statistics

Number of variables	15
Number of observations	251079
Missing cells	27459
Missing cells (%)	0.7%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	28.7 MiB
Average record size in memory	120.0 B

Variable types

Numeric	2
Categorical	3
Text	10

Alerts

`Unnamed: 0` is highly overall correlated with `brand`	High correlation
`brand` is highly overall correlated with `Unnamed: 0`	High correlation
`fuel_consumption_l_100km` has 26873 (10.7%) missing values	Missing
`Unnamed: 0` is uniformly distributed	Uniform
`Unnamed: 0` has unique values	Unique

Reproduction

Analysis started	2025-03-29 13:48:06.851414
Analysis finished	2025-03-29 13:48:38.790915
Duration	31.94 seconds
Software version	ydata-profiling vv4.12.2
Download configuration	config.json

Unnamed: 0
Real number (ℝ)

High correlation Uniform Unique

Distinct	251079
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	125539

Minimum	0
Maximum	251078
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	1.9 MiB

Quantile statistics

Minimum	0
5-th percentile	12553.9
Q1	62769.5
median	125539
Q3	188308.5
95-th percentile	238524.1
Maximum	251078
Range	251078
Interquartile range (IQR)	125539

Descriptive statistics

Standard deviation	72480.408
Coefficient of variation (CV)	0.57735372
Kurtosis	-1.2
Mean	125539
Median Absolute Deviation (MAD)	62770
Skewness	0
Sum	3.1520207 × 10¹⁰
Variance	5.2534096 × 10⁹
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
251078	1	< 0.1%
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
251062	1	< 0.1%
251061	1	< 0.1%
251060	1	< 0.1%
Other values (251069)	251069	> 99.9%

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
251078	1	< 0.1%
251077	1	< 0.1%
251076	1	< 0.1%
251075	1	< 0.1%
251074	1	< 0.1%
251073	1	< 0.1%
251072	1	< 0.1%
251071	1	< 0.1%
251070	1	< 0.1%
251069	1	< 0.1%

brand
Categorical

High correlation

Distinct	47
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.9 MiB

volkswagen	33281
mercedes-benz	27226
audi	21161
opel	20388
bmw	19810
Other values (42)	129213

Length

Max length	13
Median length	11
Mean length	6.439304
Min length	3

Characters and Unicode

Total characters	1616774
Distinct characters	25
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	alfa-romeo
2nd row	alfa-romeo
3rd row	alfa-romeo
4th row	alfa-romeo
5th row	alfa-romeo

Common Values

Value	Count	Frequency (%)
volkswagen	33281	13.3%
mercedes-benz	27226	10.8%
audi	21161	8.4%
opel	20388	8.1%
bmw	19810	7.9%
ford	18790	7.5%
skoda	14039	5.6%
seat	11949	4.8%
renault	8694	3.5%
toyota	8228	3.3%
Other values (37)	67513	26.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
volkswagen	33281	13.3%
mercedes-benz	27226	10.8%
audi	21161	8.4%
opel	20388	8.1%
bmw	19810	7.9%
ford	18790	7.5%
skoda	14039	5.6%
seat	11949	4.8%
renault	8694	3.5%
toyota	8228	3.3%
Other values (37)	67513	26.9%

Most occurring characters

Value	Count	Frequency (%)
e	214526	13.3%
a	150309	9.3%
o	133918	8.3%
s	103866	6.4%
d	101592	6.3%
n	98464	6.1%
r	76839	4.8%
l	72772	4.5%
i	64956	4.0%
m	60892	3.8%
Other values (15)	538640	33.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1616774	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	214526	13.3%
a	150309	9.3%
o	133918	8.3%
s	103866	6.4%
d	101592	6.3%
n	98464	6.1%
r	76839	4.8%
l	72772	4.5%
i	64956	4.0%
m	60892	3.8%
Other values (15)	538640	33.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1616774	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	214526	13.3%
a	150309	9.3%
o	133918	8.3%
s	103866	6.4%
d	101592	6.3%
n	98464	6.1%
r	76839	4.8%
l	72772	4.5%
i	64956	4.0%
m	60892	3.8%
Other values (15)	538640	33.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1616774	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	214526	13.3%
a	150309	9.3%
o	133918	8.3%
s	103866	6.4%
d	101592	6.3%
n	98464	6.1%
r	76839	4.8%
l	72772	4.5%
i	64956	4.0%
m	60892	3.8%
Other values (15)	538640	33.3%

model
Text

Distinct	1312
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	1.9 MiB

Length

Max length	33
Median length	28
Mean length	12.960865
Min length	3

Characters and Unicode

Total characters	3254201
Distinct characters	73
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	121 ?
Unique (%)	< 0.1%

Sample

1st row	Alfa Romeo GTV
2nd row	Alfa Romeo 164
3rd row	Alfa Romeo Spider
4th row	Alfa Romeo Spider
5th row	Alfa Romeo 164

Value	Count	Frequency (%)
volkswagen	33281	5.9%
mercedes-benz	27226	4.8%
audi	21161	3.7%
opel	20388	3.6%
bmw	19810	3.5%
ford	18790	3.3%
skoda	14039	2.5%
seat	11949	2.1%
golf	10600	1.9%
renault	8694	1.5%
Other values (984)	378678	67.1%

Most occurring characters

Value	Count	Frequency (%)
	313537	9.6%
e	266619	8.2%
a	243348	7.5%
o	211184	6.5%
n	146559	4.5%
r	140155	4.3%
s	126681	3.9%
d	118457	3.6%
i	115766	3.6%
l	103441	3.2%
Other values (63)	1468454	45.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	3254201	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	313537	9.6%
e	266619	8.2%
a	243348	7.5%
o	211184	6.5%
n	146559	4.5%
r	140155	4.3%
s	126681	3.9%
d	118457	3.6%
i	115766	3.6%
l	103441	3.2%
Other values (63)	1468454	45.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	3254201	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	313537	9.6%
e	266619	8.2%
a	243348	7.5%
o	211184	6.5%
n	146559	4.5%
r	140155	4.3%
s	126681	3.9%
d	118457	3.6%
i	115766	3.6%
l	103441	3.2%
Other values (63)	1468454	45.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	3254201	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	313537	9.6%
e	266619	8.2%
a	243348	7.5%
o	211184	6.5%
n	146559	4.5%
r	140155	4.3%
s	126681	3.9%
d	118457	3.6%
i	115766	3.6%
l	103441	3.2%
Other values (63)	1468454	45.1%

color
Categorical

Distinct	14
Distinct (%)	< 0.1%
Missing	166
Missing (%)	0.1%
Memory size	1.9 MiB

black	58720
grey	46786
white	40640
silver	34362
blue	32092
Other values (9)	38313

Length

Max length	6
Median length	5
Mean length	4.6752978
Min length	3

Characters and Unicode

Total characters	1173093
Distinct characters	20
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	red
2nd row	black
3rd row	black
4th row	black
5th row	red

Common Values

Value	Count	Frequency (%)
black	58720	23.4%
grey	46786	18.6%
white	40640	16.2%
silver	34362	13.7%
blue	32092	12.8%
red	21258	8.5%
brown	4415	1.8%
green	3500	1.4%
orange	3367	1.3%
beige	2420	1.0%
Other values (4)	3353	1.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
black	58720	23.4%
grey	46786	18.6%
white	40640	16.2%
silver	34362	13.7%
blue	32092	12.8%
red	21258	8.5%
brown	4415	1.8%
green	3500	1.4%
orange	3367	1.3%
beige	2420	1.0%
Other values (4)	3353	1.3%

Most occurring characters

Value	Count	Frequency (%)
e	193118	16.5%
l	129720	11.1%
r	114274	9.7%
b	98233	8.4%
i	77830	6.6%
a	62087	5.3%
c	58720	5.0%
k	58720	5.0%
g	56653	4.8%
y	48565	4.1%
Other values (10)	275173	23.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1173093	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	193118	16.5%
l	129720	11.1%
r	114274	9.7%
b	98233	8.4%
i	77830	6.6%
a	62087	5.3%
c	58720	5.0%
k	58720	5.0%
g	56653	4.8%
y	48565	4.1%
Other values (10)	275173	23.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1173093	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	193118	16.5%
l	129720	11.1%
r	114274	9.7%
b	98233	8.4%
i	77830	6.6%
a	62087	5.3%
c	58720	5.0%
k	58720	5.0%
g	56653	4.8%
y	48565	4.1%
Other values (10)	275173	23.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1173093	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	193118	16.5%
l	129720	11.1%
r	114274	9.7%
b	98233	8.4%
i	77830	6.6%
a	62087	5.3%
c	58720	5.0%
k	58720	5.0%
g	56653	4.8%
y	48565	4.1%
Other values (10)	275173	23.5%

registration_date
Text

Distinct	433
Distinct (%)	0.2%
Missing	4
Missing (%)	< 0.1%
Memory size	1.9 MiB

Length

Max length	13
Median length	7
Mean length	7.0001155
Min length	2

Characters and Unicode

Total characters	1757554
Distinct characters	49
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	83 ?
Unique (%)	< 0.1%

Sample

1st row	10/1995
2nd row	02/1995
3rd row	02/1995
4th row	07/1995
5th row	11/1996

Value	Count	Frequency (%)
03/2023	4746	1.9%
05/2023	4128	1.6%
02/2023	3430	1.4%
04/2023	3250	1.3%
01/2023	2996	1.2%
05/2019	2920	1.2%
03/2019	2904	1.2%
04/2019	2729	1.1%
06/2023	2543	1.0%
06/2019	2532	1.0%
Other values (426)	218943	87.2%

Most occurring characters

Value	Count	Frequency (%)
0	517673	29.5%
2	394771	22.5%
1	264667	15.1%
/	250882	14.3%
3	59119	3.4%
9	58182	3.3%
8	46460	2.6%
6	43628	2.5%
7	43127	2.5%
5	41426	2.4%
Other values (39)	37619	2.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1757554	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	517673	29.5%
2	394771	22.5%
1	264667	15.1%
/	250882	14.3%
3	59119	3.4%
9	58182	3.3%
8	46460	2.6%
6	43628	2.5%
7	43127	2.5%
5	41426	2.4%
Other values (39)	37619	2.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1757554	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	517673	29.5%
2	394771	22.5%
1	264667	15.1%
/	250882	14.3%
3	59119	3.4%
9	58182	3.3%
8	46460	2.6%
6	43628	2.5%
7	43127	2.5%
5	41426	2.4%
Other values (39)	37619	2.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1757554	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	517673	29.5%
2	394771	22.5%
1	264667	15.1%
/	250882	14.3%
3	59119	3.4%
9	58182	3.3%
8	46460	2.6%
6	43628	2.5%
7	43127	2.5%
5	41426	2.4%
Other values (39)	37619	2.1%

year
Text

Distinct	91
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.9 MiB

Length

Max length	10
Median length	4
Mean length	4.0021308
Min length	3

Characters and Unicode

Total characters	1004851
Distinct characters	39
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	48 ?
Unique (%)	< 0.1%

Sample

1st row	1995
2nd row	1995
3rd row	1995
4th row	1995
5th row	1996

Value	Count	Frequency (%)
2019	29225	11.6%
2018	24095	9.6%
2023	21097	8.4%
2022	20653	8.2%
2017	18940	7.5%
2020	18566	7.4%
2021	16022	6.4%
2016	15072	6.0%
2015	12712	5.1%
2014	10623	4.2%
Other values (82)	64093	25.5%

Most occurring characters

Value	Count	Frequency (%)
2	355576	35.4%
0	305808	30.4%
1	168039	16.7%
9	40320	4.0%
3	32554	3.2%
8	29422	2.9%
7	23313	2.3%
6	19284	1.9%
5	16299	1.6%
4	13286	1.3%
Other values (29)	950	0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1004851	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
2	355576	35.4%
0	305808	30.4%
1	168039	16.7%
9	40320	4.0%
3	32554	3.2%
8	29422	2.9%
7	23313	2.3%
6	19284	1.9%
5	16299	1.6%
4	13286	1.3%
Other values (29)	950	0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1004851	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
2	355576	35.4%
0	305808	30.4%
1	168039	16.7%
9	40320	4.0%
3	32554	3.2%
8	29422	2.9%
7	23313	2.3%
6	19284	1.9%
5	16299	1.6%
4	13286	1.3%
Other values (29)	950	0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1004851	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
2	355576	35.4%
0	305808	30.4%
1	168039	16.7%
9	40320	4.0%
3	32554	3.2%
8	29422	2.9%
7	23313	2.3%
6	19284	1.9%
5	16299	1.6%
4	13286	1.3%
Other values (29)	950	0.1%

price_in_euro
Text

Distinct	18228
Distinct (%)	7.3%
Missing	0
Missing (%)	0.0%
Memory size	1.9 MiB

Length

Max length	32
Median length	5
Mean length	4.818129
Min length	2

Characters and Unicode

Total characters	1209731
Distinct characters	70
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	8539 ?
Unique (%)	3.4%

Sample

1st row	1300
2nd row	24900
3rd row	5900
4th row	4900
5th row	17950

Value	Count	Frequency (%)
19990	1592	0.6%
16990	1404	0.6%
17990	1373	0.5%
15990	1316	0.5%
14990	1303	0.5%
18990	1281	0.5%
13990	1191	0.5%
24990	1157	0.5%
12990	1111	0.4%
22990	1074	0.4%
Other values (18238)	238424	94.9%

Most occurring characters

Value	Count	Frequency (%)
0	299465	24.8%
9	261963	21.7%
1	115823	9.6%
2	101666	8.4%
5	91997	7.6%
8	86034	7.1%
4	83414	6.9%
3	69382	5.7%
7	52981	4.4%
6	45065	3.7%
Other values (60)	1941	0.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1209731	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	299465	24.8%
9	261963	21.7%
1	115823	9.6%
2	101666	8.4%
5	91997	7.6%
8	86034	7.1%
4	83414	6.9%
3	69382	5.7%
7	52981	4.4%
6	45065	3.7%
Other values (60)	1941	0.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1209731	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	299465	24.8%
9	261963	21.7%
1	115823	9.6%
2	101666	8.4%
5	91997	7.6%
8	86034	7.1%
4	83414	6.9%
3	69382	5.7%
7	52981	4.4%
6	45065	3.7%
Other values (60)	1941	0.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1209731	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	299465	24.8%
9	261963	21.7%
1	115823	9.6%
2	101666	8.4%
5	91997	7.6%
8	86034	7.1%
4	83414	6.9%
3	69382	5.7%
7	52981	4.4%
6	45065	3.7%
Other values (60)	1941	0.2%

power_kw
Text

Distinct	596
Distinct (%)	0.2%
Missing	134
Missing (%)	0.1%
Memory size	1.9 MiB

Length

Max length	17
Median length	3
Mean length	2.6023272
Min length	1

Characters and Unicode

Total characters	653041
Distinct characters	37
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	118 ?
Unique (%)	< 0.1%

Sample

1st row	148
2nd row	191
3rd row	110
4th row	110
5th row	132

Value	Count	Frequency (%)
110	25986	10.3%
140	9865	3.9%
96	9507	3.8%
81	9055	3.6%
85	8987	3.6%
103	8297	3.3%
100	6553	2.6%
74	6202	2.5%
135	5999	2.4%
92	5783	2.3%
Other values (559)	154940	61.7%

Most occurring characters

Value	Count	Frequency (%)
1	177730	27.2%
0	109346	16.7%
5	69903	10.7%
2	50427	7.7%
8	44977	6.9%
3	43831	6.7%
4	42685	6.5%
7	40850	6.3%
6	38139	5.8%
9	34158	5.2%
Other values (27)	995	0.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	653041	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	177730	27.2%
0	109346	16.7%
5	69903	10.7%
2	50427	7.7%
8	44977	6.9%
3	43831	6.7%
4	42685	6.5%
7	40850	6.3%
6	38139	5.8%
9	34158	5.2%
Other values (27)	995	0.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	653041	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	177730	27.2%
0	109346	16.7%
5	69903	10.7%
2	50427	7.7%
8	44977	6.9%
3	43831	6.7%
4	42685	6.5%
7	40850	6.3%
6	38139	5.8%
9	34158	5.2%
Other values (27)	995	0.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	653041	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	177730	27.2%
0	109346	16.7%
5	69903	10.7%
2	50427	7.7%
8	44977	6.9%
3	43831	6.7%
4	42685	6.5%
7	40850	6.3%
6	38139	5.8%
9	34158	5.2%
Other values (27)	995	0.2%

power_ps
Text

Distinct	578
Distinct (%)	0.2%
Missing	129
Missing (%)	0.1%
Memory size	1.9 MiB

Length

Max length	17
Median length	3
Mean length	2.8534728
Min length	1

Characters and Unicode

Total characters	716079
Distinct characters	36
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	117 ?
Unique (%)	< 0.1%

Sample

1st row	201
2nd row	260
3rd row	150
4th row	150
5th row	179

Value	Count	Frequency (%)
150	25987	10.4%
190	9866	3.9%
131	9507	3.8%
110	9068	3.6%
116	8987	3.6%
140	8298	3.3%
136	6554	2.6%
101	6202	2.5%
184	5999	2.4%
125	5785	2.3%
Other values (551)	154820	61.7%

Most occurring characters

Value	Count	Frequency (%)
1	208758	29.2%
0	121450	17.0%
2	73507	10.3%
5	71949	10.0%
3	45526	6.4%
6	45060	6.3%
9	44281	6.2%
4	43522	6.1%
7	33309	4.7%
8	28194	3.9%
Other values (26)	523	0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	716079	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	208758	29.2%
0	121450	17.0%
2	73507	10.3%
5	71949	10.0%
3	45526	6.4%
6	45060	6.3%
9	44281	6.2%
4	43522	6.1%
7	33309	4.7%
8	28194	3.9%
Other values (26)	523	0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	716079	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	208758	29.2%
0	121450	17.0%
2	73507	10.3%
5	71949	10.0%
3	45526	6.4%
6	45060	6.3%
9	44281	6.2%
4	43522	6.1%
7	33309	4.7%
8	28194	3.9%
Other values (26)	523	0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	716079	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	208758	29.2%
0	121450	17.0%
2	73507	10.3%
5	71949	10.0%
3	45526	6.4%
6	45060	6.3%
9	44281	6.2%
4	43522	6.1%
7	33309	4.7%
8	28194	3.9%
Other values (26)	523	0.1%

transmission_type
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.9 MiB

Automatic	131749
Manual	117869
Unknown	1144
Semi-automatic	317

Length

Max length	14
Median length	9
Mean length	7.5888505
Min length	6

Characters and Unicode

Total characters	1905401
Distinct characters	17
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Manual
2nd row	Manual
3rd row	Unknown
4th row	Manual
5th row	Manual

Common Values

Value	Count	Frequency (%)
Automatic	131749	52.5%
Manual	117869	46.9%
Unknown	1144	0.5%
Semi-automatic	317	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
automatic	131749	52.5%
manual	117869	46.9%
unknown	1144	0.5%
semi-automatic	317	0.1%

Most occurring characters

Value	Count	Frequency (%)
a	368121	19.3%
t	264132	13.9%
u	249935	13.1%
o	133210	7.0%
m	132383	6.9%
i	132383	6.9%
c	132066	6.9%
A	131749	6.9%
n	121301	6.4%
M	117869	6.2%
Other values (7)	122252	6.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1905401	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	368121	19.3%
t	264132	13.9%
u	249935	13.1%
o	133210	7.0%
m	132383	6.9%
i	132383	6.9%
c	132066	6.9%
A	131749	6.9%
n	121301	6.4%
M	117869	6.2%
Other values (7)	122252	6.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1905401	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	368121	19.3%
t	264132	13.9%
u	249935	13.1%
o	133210	7.0%
m	132383	6.9%
i	132383	6.9%
c	132066	6.9%
A	131749	6.9%
n	121301	6.4%
M	117869	6.2%
Other values (7)	122252	6.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1905401	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	368121	19.3%
t	264132	13.9%
u	249935	13.1%
o	133210	7.0%
m	132383	6.9%
i	132383	6.9%
c	132066	6.9%
A	131749	6.9%
n	121301	6.4%
M	117869	6.2%
Other values (7)	122252	6.4%

fuel_type
Text

Distinct	136
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.9 MiB

Length

Max length	13
Median length	6
Mean length	6.0411544
Min length	3

Characters and Unicode

Total characters	1516807
Distinct characters	49
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	109 ?
Unique (%)	< 0.1%

Sample

1st row	Petrol
2nd row	Petrol
3rd row	Petrol
4th row	Petrol
5th row	Petrol

Value	Count	Frequency (%)
petrol	143280	56.9%
diesel	86897	34.5%
hybrid	13083	5.2%
electric	5967	2.4%
lpg	1255	0.5%
cng	508	0.2%
other	178	0.1%
unknown	96	< 0.1%
hydrogen	82	< 0.1%
km	34	< 0.1%
Other values (128)	211	0.1%

Most occurring characters

Value	Count	Frequency (%)
e	323301	21.3%
l	236172	15.6%
r	162590	10.7%
t	149487	9.9%
P	144536	9.5%
o	143494	9.5%
i	105973	7.0%
D	86899	5.7%
s	86897	5.7%
H	13165	0.9%
Other values (39)	64293	4.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1516807	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	323301	21.3%
l	236172	15.6%
r	162590	10.7%
t	149487	9.9%
P	144536	9.5%
o	143494	9.5%
i	105973	7.0%
D	86899	5.7%
s	86897	5.7%
H	13165	0.9%
Other values (39)	64293	4.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1516807	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	323301	21.3%
l	236172	15.6%
r	162590	10.7%
t	149487	9.9%
P	144536	9.5%
o	143494	9.5%
i	105973	7.0%
D	86899	5.7%
s	86897	5.7%
H	13165	0.9%
Other values (39)	64293	4.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1516807	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	323301	21.3%
l	236172	15.6%
r	162590	10.7%
t	149487	9.9%
P	144536	9.5%
o	143494	9.5%
i	105973	7.0%
D	86899	5.7%
s	86897	5.7%
H	13165	0.9%
Other values (39)	64293	4.2%

fuel_consumption_l_100km
Text

Missing

Distinct	621
Distinct (%)	0.3%
Missing	26873
Missing (%)	10.7%
Memory size	1.9 MiB

Length

Max length	17
Median length	12
Mean length	11.843791
Min length	4

Characters and Unicode

Total characters	2655449
Distinct characters	45
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	238 ?
Unique (%)	0.1%

Sample

1st row	10,9 l/100 km
2nd row	9,5 l/100 km
3rd row	7,2 l/100 km
4th row	9,5 l/100 km
5th row	8,8 l/100 km

Value	Count	Frequency (%)
km	224008	33.3%
l/100	222955	33.2%
4,9	8168	1.2%
5,1	7658	1.1%
5,5	7620	1.1%
5,9	7521	1.1%
5,3	7458	1.1%
5	6996	1.0%
5,7	6449	1.0%
5,4	6417	1.0%
Other values (499)	167069	24.8%

Most occurring characters

Value	Count	Frequency (%)
0	450193	17.0%
	448113	16.9%
1	260509	9.8%
k	224668	8.5%
m	224107	8.4%
/	223634	8.4%
l	222988	8.4%
,	200655	7.6%
5	93226	3.5%
4	70962	2.7%
Other values (35)	236394	8.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2655449	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	450193	17.0%
	448113	16.9%
1	260509	9.8%
k	224668	8.5%
m	224107	8.4%
/	223634	8.4%
l	222988	8.4%
,	200655	7.6%
5	93226	3.5%
4	70962	2.7%
Other values (35)	236394	8.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2655449	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	450193	17.0%
	448113	16.9%
1	260509	9.8%
k	224668	8.5%
m	224107	8.4%
/	223634	8.4%
l	222988	8.4%
,	200655	7.6%
5	93226	3.5%
4	70962	2.7%
Other values (35)	236394	8.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2655449	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	450193	17.0%
	448113	16.9%
1	260509	9.8%
k	224668	8.5%
m	224107	8.4%
/	223634	8.4%
l	222988	8.4%
,	200655	7.6%
5	93226	3.5%
4	70962	2.7%
Other values (35)	236394	8.9%

fuel_consumption_g_km
Text

Distinct	1500
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	1.9 MiB

Length

Max length	19
Median length	8
Mean length	8.0186953
Min length	3

Characters and Unicode

Total characters	2013326
Distinct characters	48
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	470 ?
Unique (%)	0.2%

Sample

1st row	260 g/km
2nd row	- (g/km)
3rd row	- (g/km)
4th row	225 g/km
5th row	- (g/km)

Value	Count	Frequency (%)
g/km	245650	48.6%
	36707	7.3%
0	8533	1.7%
119	4815	1.0%
km	4336	0.9%
reichweite	4324	0.9%
114	3883	0.8%
139	3389	0.7%
130	3378	0.7%
109	3363	0.7%
Other values (1199)	187019	37.0%

Most occurring characters

Value	Count	Frequency (%)
	254318	12.6%
m	249996	12.4%
k	249987	12.4%
/	246582	12.2%
g	245650	12.2%
1	215286	10.7%
2	70687	3.5%
3	51653	2.6%
0	50294	2.5%
4	48153	2.4%
Other values (38)	330720	16.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2013326	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	254318	12.6%
m	249996	12.4%
k	249987	12.4%
/	246582	12.2%
g	245650	12.2%
1	215286	10.7%
2	70687	3.5%
3	51653	2.6%
0	50294	2.5%
4	48153	2.4%
Other values (38)	330720	16.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2013326	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	254318	12.6%
m	249996	12.4%
k	249987	12.4%
/	246582	12.2%
g	245650	12.2%
1	215286	10.7%
2	70687	3.5%
3	51653	2.6%
0	50294	2.5%
4	48153	2.4%
Other values (38)	330720	16.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2013326	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	254318	12.6%
m	249996	12.4%
k	249987	12.4%
/	246582	12.2%
g	245650	12.2%
1	215286	10.7%
2	70687	3.5%
3	51653	2.6%
0	50294	2.5%
4	48153	2.4%
Other values (38)	330720	16.4%

mileage_in_km
Real number (ℝ)

Distinct	71766
Distinct (%)	28.6%
Missing	152
Missing (%)	0.1%
Infinite	0
Infinite (%)	0.0%
Mean	85340.016

Minimum	0
Maximum	3800000
Zeros	202
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	1.9 MiB

Quantile statistics

Minimum	0
5-th percentile	20
Q1	24904
median	67500
Q3	126500
95-th percentile	232000
Maximum	3800000
Range	3800000
Interquartile range (IQR)	101596

Descriptive statistics

Standard deviation	78717.061
Coefficient of variation (CV)	0.92239333
Kurtosis	60.312251
Mean	85340.016
Median Absolute Deviation (MAD)	48342
Skewness	3.0518562
Sum	2.1414114 × 10¹⁰
Variance	6.1963757 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10	6982	2.8%
50	1533	0.6%
15	1216	0.5%
20	1208	0.5%
5	1107	0.4%
100	1062	0.4%
150000	968	0.4%
100000	959	0.4%
5000	934	0.4%
125000	774	0.3%
Other values (71756)	234184	93.3%

Value	Count	Frequency (%)
0	202	0.1%
1	296	0.1%
2	255	0.1%
3	108	< 0.1%
4	76	< 0.1%
5	1107	0.4%
6	185	0.1%
7	139	0.1%
8	216	0.1%
9	200	0.1%

Value	Count	Frequency (%)
3800000	1	< 0.1%
2830000	1	< 0.1%
2580000	1	< 0.1%
2390000	1	< 0.1%
2300000	1	< 0.1%
2230456	1	< 0.1%
2223400	1	< 0.1%
2190000	1	< 0.1%
2106511	1	< 0.1%
2100000	1	< 0.1%

offer_description
Text

Distinct	200945
Distinct (%)	80.0%
Missing	1
Missing (%)	< 0.1%
Memory size	1.9 MiB

Length

Max length	50
Median length	39
Mean length	34.755056
Min length	1

Characters and Unicode

Total characters	8726230
Distinct characters	189
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	182215 ?
Unique (%)	72.6%

Sample

1st row	2.0 V6 TB
2nd row	Q4 Allrad, 3.2L GTA
3rd row	ALFA ROME 916
4th row	2.0 16V Twin Spark L
5th row	3.0i Super V6, absoluter Topzustand !

Value	Count	Frequency (%)
navi	33392	2.6%
	25379	2.0%
2.0	23561	1.8%
led	21239	1.7%
tdi	20715	1.6%
tsi	18786	1.5%
dsg	14631	1.1%
pdc	13871	1.1%
1.0	13330	1.0%
klima	12567	1.0%
Other values (100424)	1086186	84.6%

Most occurring characters

Value	Count	Frequency (%)
	1042276	11.9%
i	382671	4.4%
e	376932	4.3%
a	347252	4.0%
t	300926	3.4%
A	265750	3.0%
o	265216	3.0%
r	263116	3.0%
n	247541	2.8%
S	245460	2.8%
Other values (179)	4989090	57.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	8726230	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	1042276	11.9%
i	382671	4.4%
e	376932	4.3%
a	347252	4.0%
t	300926	3.4%
A	265750	3.0%
o	265216	3.0%
r	263116	3.0%
n	247541	2.8%
S	245460	2.8%
Other values (179)	4989090	57.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	8726230	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	1042276	11.9%
i	382671	4.4%
e	376932	4.3%
a	347252	4.0%
t	300926	3.4%
A	265750	3.0%
o	265216	3.0%
r	263116	3.0%
n	247541	2.8%
S	245460	2.8%
Other values (179)	4989090	57.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	8726230	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	1042276	11.9%
i	382671	4.4%
e	376932	4.3%
a	347252	4.0%
t	300926	3.4%
A	265750	3.0%
o	265216	3.0%
r	263116	3.0%
n	247541	2.8%
S	245460	2.8%
Other values (179)	4989090	57.2%

	Unnamed: 0	brand	color	mileage_in_km	transmission_type
Unnamed: 0	1.000	0.891	0.086	-0.099	0.151
brand	0.891	1.000	0.112	0.023	0.249
color	0.086	0.112	1.000	0.014	0.044
mileage_in_km	-0.099	0.023	0.014	1.000	0.006
transmission_type	0.151	0.249	0.044	0.006	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

	Unnamed: 0	brand	model	color	registration_date	year	price_in_euro	power_kw	power_ps	transmission_type	fuel_type	fuel_consumption_l_100km	fuel_consumption_g_km	mileage_in_km	offer_description
0	0	alfa-romeo	Alfa Romeo GTV	red	10/1995	1995	1300	148	201	Manual	Petrol	10,9 l/100 km	260 g/km	160500.0	2.0 V6 TB
1	1	alfa-romeo	Alfa Romeo 164	black	02/1995	1995	24900	191	260	Manual	Petrol	NaN	- (g/km)	190000.0	Q4 Allrad, 3.2L GTA
2	2	alfa-romeo	Alfa Romeo Spider	black	02/1995	1995	5900	110	150	Unknown	Petrol	NaN	- (g/km)	129000.0	ALFA ROME 916
3	3	alfa-romeo	Alfa Romeo Spider	black	07/1995	1995	4900	110	150	Manual	Petrol	9,5 l/100 km	225 g/km	189500.0	2.0 16V Twin Spark L
4	4	alfa-romeo	Alfa Romeo 164	red	11/1996	1996	17950	132	179	Manual	Petrol	7,2 l/100 km	- (g/km)	96127.0	3.0i Super V6, absoluter Topzustand !
5	5	alfa-romeo	Alfa Romeo Spider	red	04/1996	1996	7900	110	150	Manual	Petrol	9,5 l/100 km	225 g/km	47307.0	2.0 16V Twin Spark
6	6	alfa-romeo	Alfa Romeo 145	red	12/1996	1996	3500	110	150	Manual	Petrol	8,8 l/100 km	210 g/km	230000.0	Quadrifoglio
7	7	alfa-romeo	Alfa Romeo 164	black	07/1996	1996	5500	132	179	Manual	Petrol	13,4 l/100 km	320 g/km	168000.0	(3.0) V6 Super
8	8	alfa-romeo	Alfa Romeo Spider	black	07/1996	1996	8990	141	192	Manual	Petrol	11 l/100 km	265 g/km	168600.0	\|HU:neu\|Klimaanlage\|Youngtimer\|
9	9	alfa-romeo	Alfa Romeo Spider	black	01/1996	1996	6976	110	150	Manual	Petrol	9,2 l/100 km	220 g/km	99000.0	2.0 T.Spark L Klima 2.Hand *Zahnriemen

	Unnamed: 0	brand	model	color	registration_date	year	price_in_euro	power_kw	power_ps	transmission_type	fuel_type	fuel_consumption_l_100km	fuel_consumption_g_km	mileage_in_km	offer_description
251069	251069	volvo	Volvo V90 Cross Country	silver	03/2023	2023	77900	173	235	Automatic	Diesel	5,5 l/100 km	144 g/km	2500.0	B5 D AWD Geartronic ULTIMATE
251070	251070	volvo	Volvo V90 Cross Country	silver	01/2023	2023	65422	145	197	Automatic	Diesel	6,5 l/100 km	170 g/km	1506.0	B4 DIESEL PLUS AWD MY23 SELEKT
251071	251071	volvo	Volvo XC60	silver	04/2023	2023	81350	228	310	Automatic	Hybrid	7,4 l/100 km	167 g/km	60.0	XC 60 T8 AWD Ultimate Dark PHEV NAVI,AHK,STHZ,AHK,
251072	251072	volvo	Volvo XC60	silver	05/2023	2023	55400	145	197	Automatic	Diesel	5,6 l/100 km	142 g/km	5000.0	B4 Autom. Plus Dark Keyless-Start/Klima/LED/BC
251073	251073	volvo	Volvo XC60	silver	03/2023	2023	54500	145	197	Automatic	Diesel	5,6 l/100 km	142 g/km	5900.0	B4 Autom. Plus Dark Sitzhzg.
251074	251074	volvo	Volvo XC40	white	04/2023	2023	57990	192	261	Automatic	Hybrid	NaN	43 km Reichweite	1229.0	Plus Bright T5 Recharge Intellisafe*Surround+Pilot
251075	251075	volvo	Volvo XC90	white	03/2023	2023	89690	173	235	Automatic	Diesel	7,6 l/100 km	202 g/km	4900.0	B5 AWD Diesel Ultimate Dark 7-Sitzer Massage Four-
251076	251076	volvo	Volvo V60	white	05/2023	2023	61521	145	197	Automatic	Diesel	4,7 l/100 km	125 g/km	1531.0	B4 D Plus Dark 145 kW, 5-türig (Diesel)
251077	251077	volvo	Volvo XC40	white	05/2023	2023	57890	132	179	Automatic	Hybrid	NaN	45 km Reichweite	1500.0	T5 Recharge Plus Dark Standh360°*beh.Lenk
251078	251078	volvo	Volvo XC40	gold	03/2023	2023	52900	160	218	Automatic	Electric	NaN	438 km Reichweite	50.0	Ultimate Recharge Twin Motor AHK GJR

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)